@echo off
cls
echo ==========================================
echo 营养系统菜品信息处理结果查看器
echo ==========================================

echo.
echo 检查数据库中的处理结果...

echo.
echo 最近处理的10个菜品：
mysql -u root -proot yingyang -e "SELECT id, name, ai_called, cook_time FROM fa_food_dish WHERE ai_called = 1 ORDER BY updatetime DESC LIMIT 10;"

echo.
echo 最近添加的食材关联记录：
mysql -u root -proot yingyang -e "SELECT dish_id, ingredient_name, ingredient_id, quantity FROM fa_food_ingredientrel ORDER BY createtime DESC LIMIT 10;"

echo.
echo 未处理的菜品数量：
mysql -u root -proot yingyang -e "SELECT COUNT(*) as unprocessed_count FROM fa_food_dish WHERE ai_called = 0;"

echo.
echo 处理成功的菜品数量：
mysql -u root -proot yingyang -e "SELECT COUNT(*) as processed_count FROM fa_food_dish WHERE ai_called = 1;"

echo.
pause